﻿CREATE TABLE [dbo].[DimCLM_835]
(
[RecordID] [bigint] NULL,
[ActivityID] [nvarchar] (128) NULL,
[ReceiveClaimPayment] [datetime] NULL,
[ClaimPayment_CLP01_PatientAccountNumber] [nvarchar] (100) NULL,
[Subscriber_NM109_SubscriberID] [nvarchar] (100) NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[ProviderSummary_TS309_TotalActualPaymentAmount] [float] NULL,
[Payer_NM104_PayerIdentifier] [nvarchar] (100) NULL,
[ProviderSummary_TS306_TotalCoveredChargeAmount] [float] NULL,
[ProviderSummary_TS307_TotalNonCoveredChargeAmount] [float] NULL,
[ProviderSummary_TS308_TotalDeniedChargeAmount] [float] NULL,
[ProviderSummary_TS305_TotalClaimChargeAmount] [float] NULL,
[BTSInterchangeID] [nvarchar] (100) NULL,
[IsDependent] [nvarchar] (50) NULL,
[Patient_NM109_PatientIdentifier] [nvarchar] (100) NULL,
[ClaimPayment_CLP02_ClaimStatusCode] [nvarchar] (50) NULL,
[ClaimPayment_CLP03_TotalClaimChargeAmount] [float] NULL,
[ClaimPayment_CLP04_ClaimPaymentAmount] [float] NULL,
[ClaimPayment_CLP05_PatientResponsibilityAmount] [float] NULL,
[ClaimPayment_CLP06_ClaimFilingIDCode] [nvarchar] (50) NULL,
[ClaimPayment_CLP07_PayerClaimControlNumber] [nvarchar] (50) NULL,
[CLM_835_ID_Key] [int] NOT NULL IDENTITY(1, 1),
[Receive_UTC] [datetime] NULL,
[Receive_LocalTime] AS (dateadd(hour, -datediff(hour,getdate(),getutcdate()),[Receive_UTC])),
[PaymentStatus] [nvarchar] (50) NULL,
[InsertDate] [datetime] NULL,
[Payer_NM102_PayerName] [nvarchar] (100) NULL,
[Payer_N401_AddressCity] [nvarchar] (100) NULL,
[Payer_N402_AddressState] [nvarchar] (50) NULL,
[Payer_Per02_ContactName] [nvarchar] (100) NULL,
[Payer_Per04_CommunicationNumber] [nvarchar] (50) NULL,
[ClaimPayment_CLP08_FacilityTypeCode] [nvarchar] (50) NULL,
[ClaimPayment_CLP11_DRGCode] [nvarchar] (50) NULL,
[ClaimPayment_CLP12_DRGWeight] [nvarchar] (50) NULL,
[ClaimPayment_CLP13_DischargeFraction] [nvarchar] (50) NULL
) ON [PRIMARY]


